Ontop: answering SPARQL queries over relational databases

We present Ontop, an open-source Ontology-Based Data Access (OBDA) system that allows for querying relational data sources through a conceptual representation of the domain of interest, provided in terms of an ontology, to which the data sources are mapped. Key features of Ontop are its solid theoretical foundations, a virtual approach to OBDA, which avoids materializing triples and is implemented through the query rewriting technique, extensive optimizations exploiting all elements of the OBDA architecture, its compliance to all relevant W3C recommendations (including SPARQL queries, R2RML mappings, and OWL2QL and RDFS ontologies), and its support for all major relational databases

Efficient handling of SPARQL OPTIONAL for OBDA

OPTIONAL is a key feature in SPARQL for dealing with missing information. While this operator is used extensively, it is also known for its complexity, which can make efficient evaluation of queries with OPTIONAL challenging. We tackle this problem in the Ontology-Based Data Access (OBDA) setting, where the data is stored in a SQL relational database and exposed as a virtual RDF graph by means of an R2RML mapping. We start with a succinct translation of a SPARQL fragment into SQL. It fully respects bag semantics and three-valued logic and relies on the extensive use of the LEFT JOIN operator and COALESCE function. We then propose optimisation techniques for reducing the size and improving the structure of generated SQL queries. Our optimisations capture interactions between JOIN, LEFT JOIN, COALESCE and integrity constraints such as attribute nullability, uniqueness and foreign key constraints. Finally, we empirically verify effectiveness of our techniques on the BSBM OBDA benchmark

SPARQL-to-SQL on Internet of Things Databases and Streams

To realise a semantic Web of Things, the challenge of achieving efficient Resource Description Format (RDF) storage and SPARQL query performance on Internet of Things (IoT) devices with limited resources has to be addressed. State-of-the-art SPARQL-to-SQL engines have been shown to outperform RDF stores on some benchmarks. In this paper, we describe an optimisation to the SPARQL-to-SQL approach, based on a study of time-series IoT data structures, that employs metadata abstraction and efficient translation by reusing existing SPARQL engines to produce Linked Data ‘just-in-time’. We evaluate our approach against RDF stores, state-of-the-art SPARQL-to-SQL engines and streaming SPARQL engines, in the context of IoT data and scenarios. We show that storage efficiency, with succinct row storage, and query performance can be improved from 2 times to 3 orders of magnitude

Knowledge, attitudes and preventive practices of primary health care professionals towards alcohol use: A national, cross-sectional study

Introduction Primary care (PC) professionals' knowledge about alcohol use has been identified as one of the barriers PC providers face in their clinic. Both PC professionals' level of training and attitude are crucial in the clinical practice regarding alcohol use. Objective To evaluate the knowledge, attitude, and preventive practices of Spanish PC physicians and nurses towards alcohol use. Design An observational, descriptive, cross-sectional, multi-center study. Methodology Location: PC centers of the Spanish National Health System (NHS). Participants: PC physicians and nurses selected randomly from health care centers, and by sending an e-mail to semFYC and SEMERGEN members. Healthcare providers completed an online survey on knowledge, attitude, and follow-up recommendations for reducing alcohol intake. A descriptive, bivariate, and multivariate statistical analysis was conducted (p<0.05). Results Participants: 1, 760 healthcare providers completed the survey (75.6% [95% CI 73.5-77.6] family physicians; 11.4% [95% CI 9.9-12.9] medical residents; and 12.5% [95% CI 10.9-14.1] nurses), with a mean age of 44.7 (SD 11.24, range: 26-64, 95% CI: 47.2-48.2). Knowledge was higher in family physicians (p<0.001), older professionals (Spearman's r = 0.11, p<0.001), and resident trainers (p<0.001). The PC professional most likely to provide advice for reducing alcohol use was: a nurse (p<0.001), female (p = 0.010), between 46 and 55 years old (p <0.001). Conclusions PC providers' knowledge and preventive practices regarding alcohol use are scarce, hence specific training strategies to increase their knowledge and improve their attitude and skills with regard to this health problem should be considered a healthcare policy priority

Horn fragments of the Halpern-Shoham Interval Temporal Logic

We investigate the satisfiability problem for Horn fragments of the Halpern-Shoham interval temporal logic depending on the type (box or diamond) of the interval modal operators, the type of the underlying linear order (discrete or dense), and the type of semantics for the interval relations (reflexive or irreflexive). For example, we show that satisfiability of Horn formulas with diamonds is undecidable for any type of linear orders and semantics. On the contrary, satisfiability of Horn formulas with boxes is tractable over both discrete and dense orders under the reflexive semantics and over dense orders under the irreflexive semantics but becomes undecidable over discrete orders under the irreflexive semantics. Satisfiability of binary Horn formulas with both boxes and diamonds is always undecidable under the irreflexive semantics

How does study quality affect the results of a diagnostic meta-analysis?

Background: The use of systematic literature review to inform evidence based practice in diagnostics is rapidly expanding. Although the primary diagnostic literature is extensive, studies are often of low methodological quality or poorly reported. There has been no rigorously evaluated, evidence based tool to assess the methodological quality of diagnostic studies. The primary objective of this study was to determine the extent to which variations in the quality of primary studies impact the results of a diagnostic meta-analysis and whether this differs with diagnostic test type. A secondary objective was to contribute to the evaluation of QUADAS, an evidence-based tool for the assessment of quality in diagnostic accuracy studies. Methods: This study was conducted as part of large systematic review of tests used in the diagnosis and further investigation of urinary tract infection (UTI) in children. All studies included in this review were assessed using QUADAS, an evidence-based tool for the assessment of quality in systematic reviews of diagnostic accuracy studies. The impact of individual components of QUADAS on a summary measure of diagnostic accuracy was investigated using regression analysis. The review divided the diagnosis and further investigation of UTI into the following three clinical stages: diagnosis of UTI, localisation of infection, and further investigation of the UTI. Each stage used different types of diagnostic test, which were considered to involve different quality concerns. Results: Many of the studies included in our review were poorly reported. The proportion of QUADAS items fulfilled was similar for studies in different sections of the review. However, as might be expected, the individual items fulfilled differed between the three clinical stages. Regression analysis found that different items showed a strong association with test performance for the different tests evaluated. These differences were observed both within and between the three clinical stages assessed by the review. The results of regression analyses were also affected by whether or not a weighting (by sample size) was applied. Our analysis was severely limited by the completeness of reporting and the differences between the index tests evaluated and the reference standards used to confirm diagnoses in the primary studies. Few tests were evaluated by sufficient studies to allow meaningful use of meta-analytic pooling and investigation of heterogeneity. This meant that further analysis to investigate heterogeneity could only be undertaken using a subset of studies, and that the findings are open to various interpretations. Conclusion: Further work is needed to investigate the influence of methodological quality on the results of diagnostic meta-analyses. Large data sets of well-reported primary studies are needed to address this question. Without significant improvements in the completeness of reporting of primary studies, progress in this area will be limited

Minimizing conservativity violations in ontology alignments: algorithms and evaluation

In order to enable interoperability between ontology-based systems, ontology matching techniques have been proposed. However, when the generated mappings lead to undesired logical consequences, their usefulness may be diminished. In this paper, we present an approach to detect and minimize the violations of the so-called conservativity principle where novel subsumption entailments between named concepts in one of the input ontologies are considered as unwanted. The practical applicability of the proposed approach is experimentally demonstrated on the datasets from the Ontology Alignment Evaluation Initiative

Drosophila IAP1-Mediated Ubiquitylation Controls Activation of the Initiator Caspase DRONC Independent of Protein Degradation

Ubiquitylation targets proteins for proteasome-mediated degradation and plays important roles in many biological processes including apoptosis. However, non-proteolytic functions of ubiquitylation are also known. In Drosophila, the inhibitor of apoptosis protein 1 (DIAP1) is known to ubiquitylate the initiator caspase DRONC in vitro. Because DRONC protein accumulates in diap1 mutant cells that are kept alive by caspase inhibition (“undead” cells), it is thought that DIAP1-mediated ubiquitylation causes proteasomal degradation of DRONC, protecting cells from apoptosis. However, contrary to this model, we show here that DIAP1-mediated ubiquitylation does not trigger proteasomal degradation of full-length DRONC, but serves a non-proteolytic function. Our data suggest that DIAP1-mediated ubiquitylation blocks processing and activation of DRONC. Interestingly, while full-length DRONC is not subject to DIAP1-induced degradation, once it is processed and activated it has reduced protein stability. Finally, we show that DRONC protein accumulates in “undead” cells due to increased transcription of dronc in these cells. These data refine current models of caspase regulation by IAPs

An extended scattered light disk around AT Pyx: possible planet formation in a cometary globule

Stars and planetary system

Interferon-Alpha Administration Enhances CD8+ T Cell Activation in HIV Infection

Type I interferons play important roles in innate immune defense. In HIV infection, type I interferons may delay disease progression by inhibiting viral replication while at the same time accelerating disease progression by contributing to chronic immune activation.To investigate the effects of type I interferons in HIV-infection, we obtained cryopreserved peripheral blood mononuclear cell samples from 10 subjects who participated in AIDS Clinical Trials Group Study 5192, a trial investigating the activity of systemic administration of IFNα for twelve weeks to patients with untreated HIV infection. Using flow cytometry, we examined changes in cell cycle status and expression of activation antigens by circulating T cells and their maturation subsets before, during and after IFNα treatment.The proportion of CD38+HLA-DR+CD8+ T cells increased from a mean of 11.7% at baseline to 24.1% after twelve weeks of interferon treatment (p = 0.006). These frequencies dropped to an average of 20.1% six weeks after the end of treatment. In contrast to CD8+ T cells, the frequencies of activated CD4+ T cells did not change with administration of type I interferon (mean percentage of CD38+DR+ cells = 2.62% at baseline and 2.17% after 12 weeks of interferon therapy). As plasma HIV levels fell with interferon therapy, this was correlated with a "paradoxical" increase in CD8+ T cell activation (p<0.001).Administration of type I interferon increased expression of the activation markers CD38 and HLA DR on CD8+ T cells but not on CD4+ T cells of HIV+ persons. These observations suggest that type I interferons may contribute to the high levels of CD8+ T cell activation that occur during HIV infection